home *** CD-ROM | disk | FTP | other *** search
- PROD: REFLEX.EXE
- MENU: 3,Continue,Hands-On,Exit to DOS, Select Choice:
- DEF: 5
- BOX: 12,4,5,40,100
- Hmmmm...a fatal error occurred.
- Please reinstall the Trial Version
- of Reflex 2.0 and try again. If it
- fails again, call Borland's Technical
- Support.
- CMT: START OF THE SCRIPT
- KEYS: <F10>
- BOX: 10,18,5,46,140
- Welcome to Reflex 2.0!
-
- This second demonstration shows you
- how to use Reflex 2.0 to analyze an
- existing database.
- KEYS: <ESC><@Q>n
- BOX: 10,18,5,46,120
-
- The demonstration is self-running, so
- you don't have to type anything. Just
- sit back and watch.
-
- BOX: 10,18,5,46,160
- If you wish to pause the demonstration,
- just press a key. You can then press:
- C to Continue
- H to try Reflex 2.0 for yourself
- E to Exit to DOS
-
- DLY:5
- BOX: 10,18,5,46,140
- For the next few minutes, we'll take you
- on a tour of Reflex 2.0, the remarkable
- database program that makes it easy to
- manage, graph, and analyze your data.
-
- DLY: 10
- BOX: 10,18,5,46,140
- In order to see the benefits of data
- management with Reflex's multiple views,
- let's look at a database that has already
- been created.
-
- DLY: 10
- BOX: 10,18,5,46,100
-
- Imagine that you're the regional sales
- manager of a winery.
-
-
- DLY: 10
- BOX: 10,18,5,46,100
-
- You track the monthly sales made by
- your four sales representatives.
-
-
- KEYS: <F10>d
- DLY: 20
- KEYS: <DNA>
- DLY: 20
- KEYS: Owine<ENT>
- DLY: 20
- KEYS: <ENT>
- BOX: 10,18,5,46,140
-
- This sample file was saved with three
- views open. Let's zoom the List View to
- learn more about this particular database.
-
- KEYS: <F5><HME>
- BOX: 10,18,5,46,100
-
- Here is a field showing the date of
- each sale.
-
-
- KEYS: <RTA>
- BOX: 10,18,5,46,100
-
- The next field shows the sales
- representative who made the sale.
-
-
- KEYS: <RTA>
- BOX: 10,18,5,46,90
-
-
- The third field shows the type of wine.
-
-
- KEYS: <RTA>
- BOX: 10,18,5,46,100
-
- The next field shows the number
- of cases of this particular wine
- sold by this sales representative.
-
-
- KEYS: <RTA>
- BOX: 10,18,5,46,100
-
- The next field shows the sales price
- for those cases.
-
-
- KEYS: <RTA>
- BOX: 10,18,5,46,150
- The average price per case is a field
- that is calculated automatically by
- dividing the sales by the number of
- cases sold.
-
- KEYS: <RTA>
- DLY: 10
- BOX: 10,18,5,46,90
-
-
- Next is the Cost Per Case field.
-
-
- KEYS: <RTA>
- DLY: 10
- BOX: 10,18,5,46,140
-
- The Total Cost is another calculated
- field determined by multiplying the
- number of cases by the cost per case.
-
- KEYS: <RTA>
- BOX: 10,18,5,46,140
-
- And the $ Margin field is determined
- by Sales minus Total Cost. In other
- words, this is the profit for each sale.
-
- KEYS: <HME>
- DLY: 10
- BOX: 10,18,5,46,120
-
- Let's look at how Reflex 2.0 helps us
- better understand this information.
-
-
- KEYS: <@V>G
- DLY: 10
- BOX: 16,18,5,46,140
- In the upper right window, we have a graph
- of our information. This graph contains
- two Y-axis bars -- the solid bar shows Total
- Cost and the "hatched" bar shows Sales.
-
- DLY: 10
- BOX: 16,18,5,46,120
-
- Let's move along the X-axis,
- looking at individual records...
-
-
- KEYS: <HME>
- DLY: 50
- BOX: 16,18,5,46,140
-
- Note how the Form and List views
- automatically follow the graph.
- All Reflex 2.0 views are "Hot-linked."
-
- KEYS: <RTA>
- DLY: 50
- KEYS: <RTA>
- DLY: 50
- KEYS: <LFA>
- DLY: 50
- BOX: 16,18,5,46,140
-
- This record shows us that someone
- is selling wine under cost!
-
-
- DLY: 10
- BOX: 16,18,5,46,140
-
- We see these sales were made by Ann.
- Should we have a talk with her?
-
-
- DLY: 10
- BOX: 16,18,5,46,140
-
- Before we do that, we need to see
- what these sales figures really mean.
-
-
- DLY: 10
- BOX: 16,18,5,46,140
-
- Let's get a quick summary by looking
- at this information in a Crosstab View.
-
-
- KEYS: <@V><DNA><DNA>
- DLY: 20
- KEYS: X
- DLY: 20
- KEYS: <ENT><F5>
- DLY: 10
- BOX: 16,18,5,46,140
-
- This Crosstab sums the total sales
- (by using the @SUM function with
- the Sales field).
-
- DLY: 10
- BOX: 16,18,5,46,140
-
- It is also broken down into a row for
- each sales representative and a column
- for each wine type.
-
- DLY: 10
- BOX: 16,18,5,46,140
- In addition to showing information
- "for each" value (as we have for both
- wine type and sales representative),
- Reflex 2.0 can also "make ranges" to
- categorize numeric data.
- DLY: 10
- BOX: 16,18,5,46,140
-
- For example, we can find out who sold
- 0-50 cases of wine, 50-100 cases, and
- so on.
-
- DLY: 20
- BOX: 16,18,5,46,140
- In this example, the "for each" shows
- a consolidated picture of all of the
- individual sales records. And the
- information is categorized, so we can
- make instant comparisons.
-
- DLY: 10
- BOX: 16,18,5,46,140
- Let's change the crosstab so that
- we can look more closely at $ Margin.
- To do so, we also want to change the
- summary to @avg (instead of @sum).
-
- BOX: 16,18,5,46,140
- Anytime you have to choose an item
- within Reflex 2.0, you can press F9
- to get a complete list of such items.
- Then just cursor to the one you want
- and press ENTER...
- KEYS: <F9>
- DLY: 30
- KEYS: a
- DLY: 10
- KEYS: <ENT>
- DLY: 10
- KEYS: <F9>
- DLY: 10
- KEYS: $
- DLY: 10
- KEYS: <ENT>
- DLY: 10
- BOX: 16,18,5,46,120
-
- Imagine how many spreadsheet commands
- would be necessary to duplicate this one
- "what-if!"
-
- KEYS: <DNA>
- KEYS: <F3>
- BOX: 16,18,5,46,180
- After we make these changes in the
- Crosstab View, we see that although Ann
- is losing money on Burgundy, she has
- good margins on the other wines.
-
- KEYS: <ESC>
- BOX: 16,18,5,46,140
-
- Let's change the Summary back to @sum
- to see what Ann's contribution to the
- "bottom line" is.
-
- DLY: 5
- KEYS: <TAB><F9>
- DLY: 10
- KEYS: S
- DLY: 10
- KEYS: <ENT>
- DLY: 10
- KEYS: <DNA><DNA>
- DLY: 10
- KEYS: <RTA><RTA><RTA><RTA><+F3>
- BOX: 16,18,5,46,180
-
- It turns out that Ann makes more money
- for the company than any of the other
- sales representatives!
-
- KEYS: <ESC><F5>
- DLY: 10
- BOX: 16,18,5,46,120
-
- We can look at this yet another way by
- making a pie chart comparing each rep's
- performance.
-
- KEYS: <@V>GR
- DLY: 30
- BOX: 16,18,5,46,120
-
- To make a pie chart, we'll use Graph's
- menu options to select the type of chart
- and the fields we want to see.
-
- KEYS: <@G><DNA><DNA>
- DLY: 30
- KEYS: G<RTA><RTA>
- DLY: 30
- KEYS: <@G>
- DLY: 30
- KEYS: F
- DLY: 30
- KEYS: rep<DNA>$ margin<DNA>
- DLY: 30
- KEYS: <DEL>
- DLY: 30
- KEYS: <^ENT><^ENT>
- BOX: 16,18,5,46,120
-
- No doubt about it -- Ann is the top
- sales representative. Maybe she has
- something to teach the others.
-
- BOX: 16,18,5,46,100
-
- Now that we understand this information,
- we'll want to communicate it to others.
-
-
- BOX: 16,18,5,46,140
- Reflex 2.0 makes this easy by allowing
- us to print any view. We could plot
- this graph on our printer (or plotter),
- or we could print our Form, our List,
- or our Crosstab.
- BOX: 16,18,5,46,140
- Another extremely important source of
- information, of course, is a report.
- That's another area where Reflex 2.0
- shines with its flexible and powerful
- report writer.
- KEYS: <@V><DNA><DNA><DNA><DNA><DNA>
- DLY: 20
- KEYS: r
- BOX: 16,18,5,46,120
-
- Here is a predesigned report that
- shows monthly sales.
-
-
- BOX: 16,18,5,46,120
-
- We can use the "preview" feature
- to see how this report will look
- when it's printed.
-
- KEYS: <@R><DNA><DNA>
- DLY: 20
- KEYS: P
- DLY: 100
- BOX: 16,18,5,46,120
-
- We can preview the entire report, or just
- a single page.
-
-
- KEYS: <RTA>
- DLY: 10
- KEYS: <ENT>
- BOX: 16,18,5,46,140
-
- We can use the "Quick Report" feature
- to generate an instant report design
- from our Form or List view.
-
- KEYS: <@R><DNA>
- DLY: 20
- KEYS: q
- DLY: 10
- KEYS: Y
- DLY: 10
- KEYS: <RTA>
- DLY: 10
- KEYS: L
- BOX: 16,18,5,46,80
-
-
- Let's preview this one too...
-
-
- KEYS: <@R>P
- DLY: 100
- KEYS: c
- DLY: 100
- KEYS: c
- DLY: 10
- KEYS: <ESC>
- BOX: 16,18,5,46,140
- Your reports can be columnar or
- free-form. This makes it easy to
- use preprinted forms, such as those
- for overnight carriers.
-
- DLY: 10
- BOX: 16,18,5,46,140
- Another feature of Reflex 2.0 is the
- Mail Merge View. This is a hot-linked
- editor that allows you to create form
- letters.
-
- BOX: 16,18,5,46,120
-
- To demonstrate this, let's open our
- customer database.
-
-
- BOX: 16,18,5,46,140
-
- In Reflex 2.0, you never have to
- remember to save your database.
- It happens automatically.
-
- KEYS: <@D><DNA>
- DLY: 30
- KEYS: Owinemail<ENT><ENT>
- BOX: 10,18,5,46,120
- Note that our customer database is
- already using Mail Merge View. This
- is what the database looked like the
- last time it was used.
-
- BOX: 10,18,5,46,100
-
- Reflex 2.0 always picks up right where
- you left off when you open a database.
-
-
- BOX: 10,18,5,46,100
-
- Let's compose a short letter to remind
- our customers about our annual party...
-
-
- DEF: 2
- KEYS:{@today()}<ENT><ENT>Dear {Name},<ENT><ENT>
- KEYS: <TAB>Just a reminder -- don't forget the Fifth Annual Benton Bash
- KEYS: this coming Saturday, June 22, starting around noon.<ENT><ENT><TAB>
- KEYS: {@if(date of first order < 1/1/86, "Because you are a loyal
- KEYS: customer, it's free!", "Only $10.00 for all you can eat!")}
- KEYS: <ENT><ENT>The Benton Winery<^PGU>
- DLY: 50
- BOX: 16,18,5,46,140
-
- When we switch into "data" mode,
- everything inside the curly braces
- is converted to data. Watch...
-
- KEYS: <@M>
- DLY: 20
- KEYS: D
- DLY: 30
- BOX: 16,18,5,46,140
- Because Mail Merge View is hot-linked
- like all of the other views, watch what
- happens to the letter when we move
- around in List View.
-
- KEYS: <@V><DNA>
- DLY: 30
- KEYS: L<RTA><RTA>
- DLY: 30
- KEYS: <ENT><HME>
- DLY: 30
- KEYS: <DNA>
- DLY: 60
- KEYS: <DNA>
- DLY: 60
- KEYS: <DNA>
- DLY: 60
- KEYS: <DNA>
- DLY: 60
- KEYS: <DNA>
- DLY: 60
- BOX: 10,18,5,46,120
-
- Mailing labels are also easy to create
- with Reflex 2.0. Let's make the labels
- to go with these letters.
-
- DEF: 5
- KEYS: <@V><DNA><DNA><DNA><DNA><DNA>
- DLY: 30
- KEYS: R<@R>
- DLY: 30
- KEYS: M
- BOX: 16,18,5,46,120
-
- You can choose from popular built-in
- mailing labels or customize your own
- labels.
-
- KEYS: <F9>
- DLY: 10
- KEYS: <DNA>
- DLY: 40
- KEYS: <ENT><TAB>
- BOX: 16,18,5,46,100
- Then just put the field names into
- the label area. Fixed text (such as
- the comma between City and State)
- is preceded by an apostrophe.
-
- DEF: 4
- KEYS: name<DNA><^LFA>
- KEYS: Business<DNA><^LFA>
- KEYS: Address<DNA><^LFA>
- KEYS: City<RTA>',<RTA><RTA>State<RTA><RTA><RTA>Zip<ENT>
- DLY: 30
- BOX: 16,18,5,46,120
-
- We can preview this to see how it
- will look like when it's printed.
-
-
- KEYS: <@R><DNA><DNA>
- DLY: 30
- KEYS: P
- DLY: 140
- KEYS: <RTA>
- DLY: 30
- KEYS: <ENT>
- KEYS: <@D>C
- BOX: 10,18,5,46,140
- In conclusion, you can see how easy it
- is to create and customize your information
- using Reflex 2.0. This flexibility is
- unique among flat-file database products.
-
- DLY: 10
- BOX: 10,18,5,46,140
- By allowing you to look at your data in
- different ways, including graphs and
- crosstabs, Reflex 2.0 enables you to
- discover the meaning behind your data.
-
- DLY: 10
- BOX: 10,18,5,46,140
- Reflex 2.0's powerful data-analysis
- features, flexibility, and ease of use
- make it the database of choice for
- everyone who needs to store, graph,
- and analyze data.
- BOX: 10,18,5,46,140
- And that concludes the demonstration.
- To try using Reflex 2.0 on your own,
- just type REFLEX. Feel free to use
- the WINE or WINEMAIL databases, or go
- ahead and create your own database.
-